Profiling Report

Dataset statistics

Number of variables	33
Number of observations	142588
Missing cells	235837
Missing cells (%)	5.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	35.9 MiB
Average record size in memory	264.0 B

Variable types

Numeric	7
Boolean	4
Categorical	12
DateTime	3
Text	7

Alerts

`business_name` is highly overall correlated with `case_linked` and 1 other fields	High correlation
`case_linked` is highly overall correlated with `business_name` and 1 other fields	High correlation
`case_type` is highly overall correlated with `case_linked`	High correlation
`day_of_month` is highly overall correlated with `month_period`	High correlation
`hospital_id` is highly overall correlated with `month_of_year`	High correlation
`month_of_year` is highly overall correlated with `hospital_id`	High correlation
`month_period` is highly overall correlated with `day_of_month`	High correlation
`referred` is highly overall correlated with `business_name`	High correlation
`total_cxl_appointments_before_appointment` is highly overall correlated with `total_good_appointments_before_appointment`	High correlation
`total_good_appointments_before_appointment` is highly overall correlated with `total_cxl_appointments_before_appointment`	High correlation
`patient_status` is highly imbalanced (81.3%)	Imbalance
`patient_type` is highly imbalanced (62.1%)	Imbalance
`missed` is highly imbalanced (89.4%)	Imbalance
`customer_type` is highly imbalanced (64.3%)	Imbalance
`title` is highly imbalanced (58.8%)	Imbalance
`sex` is highly imbalanced (64.1%)	Imbalance
`next_appointment_time` has 116141 (81.5%) missing values	Missing
`cancelled_at` has 119696 (83.9%) missing values	Missing
`total_open_invoices_before_appointemnt` has 133150 (93.4%) zeros	Zeros
`total_good_appointments_before_appointment` has 15297 (10.7%) zeros	Zeros
`total_cxl_appointments_before_appointment` has 87748 (61.5%) zeros	Zeros
`notice` has 119702 (83.9%) zeros	Zeros

Reproduction

Analysis started	2024-06-10 11:36:25.706097
Analysis finished	2024-06-10 11:37:33.691731
Duration	1 minute and 7.99 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

hospital_id
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.531125

Minimum	2
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	2
5-th percentile	12
Q1	12
median	13
Q3	16
95-th percentile	16
Maximum	16
Range	14
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.8397643
Coefficient of variation (CV)	0.13596536
Kurtosis	-1.4498233
Mean	13.531125
Median Absolute Deviation (MAD)	1
Skewness	0.45622436
Sum	1929376
Variance	3.3847326
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
12	57664	40.4%
16	48654	34.1%
13	29681	20.8%
11	6410	4.5%
15	171	0.1%
2	8	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	8	< 0.1%
11	6410	4.5%
12	57664	40.4%
13	29681	20.8%
15	171	0.1%
16	48654	34.1%

Value	Count	Frequency (%)
16	48654	34.1%
15	171	0.1%
13	29681	20.8%
12	57664	40.4%
11	6410	4.5%
2	8	< 0.1%

case_linked
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.4 KiB

True	80639
False	61949

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	80639	56.6%
False	61949	43.4%

case_type
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Not Available	61949
Unlimited	59368
Max Sessions	21167
Max Amount	104

Length

Max length	13
Median length	12
Mean length	11.183922
Min length	9

Characters and Unicode

Total characters	1594693
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Available
2nd row	Not Available
3rd row	Not Available
4th row	Not Available
5th row	Not Available

Common Values

Value	Count	Frequency (%)
Not Available	61949	43.4%
Unlimited	59368	41.6%
Max Sessions	21167	14.8%
Max Amount	104	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
not	61949	27.4%
available	61949	27.4%
unlimited	59368	26.3%
max	21271	9.4%
sessions	21167	9.4%
amount	104	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
i	201852	12.7%
l	183266	11.5%
a	145169	9.1%
e	142484	8.9%
t	121421	7.6%
o	83220	5.2%
	83220	5.2%
n	80639	5.1%
s	63501	4.0%
A	62053	3.9%
Other values (10)	427868	26.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1594693	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	201852	12.7%
l	183266	11.5%
a	145169	9.1%
e	142484	8.9%
t	121421	7.6%
o	83220	5.2%
	83220	5.2%
n	80639	5.1%
s	63501	4.0%
A	62053	3.9%
Other values (10)	427868	26.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1594693	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	201852	12.7%
l	183266	11.5%
a	145169	9.1%
e	142484	8.9%
t	121421	7.6%
o	83220	5.2%
	83220	5.2%
n	80639	5.1%
s	63501	4.0%
A	62053	3.9%
Other values (10)	427868	26.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1594693	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	201852	12.7%
l	183266	11.5%
a	145169	9.1%
e	142484	8.9%
t	121421	7.6%
o	83220	5.2%
	83220	5.2%
n	80639	5.1%
s	63501	4.0%
A	62053	3.9%
Other values (10)	427868	26.8%

total_open_invoices_before_appointemnt
Real number (ℝ)

ZEROS

Distinct	37
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.15844251

Minimum	0
Maximum	36
Zeros	133150
Zeros (%)	93.4%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	36
Range	36
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.89940366
Coefficient of variation (CV)	5.6765302
Kurtosis	236.06917
Mean	0.15844251
Median Absolute Deviation (MAD)	0
Skewness	12.036222
Sum	22592
Variance	0.80892695
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0	133150	93.4%
1	4897	3.4%
2	1966	1.4%
3	933	0.7%
4	597	0.4%
5	267	0.2%
6	179	0.1%
7	159	0.1%
9	120	0.1%
8	92	0.1%
Other values (27)	228	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	133150	93.4%
1	4897	3.4%
2	1966	1.4%
3	933	0.7%
4	597	0.4%
5	267	0.2%
6	179	0.1%
7	159	0.1%
8	92	0.1%
9	120	0.1%

Value	Count	Frequency (%)
36	1	< 0.1%
35	1	< 0.1%
34	1	< 0.1%
33	1	< 0.1%
32	1	< 0.1%
31	1	< 0.1%
30	1	< 0.1%
29	1	< 0.1%
28	1	< 0.1%
27	2	< 0.1%

total_good_appointments_before_appointment
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	335
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.58918

Minimum	0
Maximum	334
Zeros	15297
Zeros (%)	10.7%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	10
95-th percentile	45
Maximum	334
Range	334
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	23.449078
Coefficient of variation (CV)	2.2144375
Kurtosis	44.197321
Mean	10.58918
Median Absolute Deviation (MAD)	2
Skewness	5.7101934
Sum	1509890
Variance	549.85924
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	32620	22.9%
0	15297	10.7%
2	13329	9.3%
3	10798	7.6%
4	8875	6.2%
5	7313	5.1%
6	5940	4.2%
7	4888	3.4%
8	4146	2.9%
9	3541	2.5%
Other values (325)	35841	25.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15297	10.7%
1	32620	22.9%
2	13329	9.3%
3	10798	7.6%
4	8875	6.2%
5	7313	5.1%
6	5940	4.2%
7	4888	3.4%
8	4146	2.9%
9	3541	2.5%

Value	Count	Frequency (%)
334	1	< 0.1%
333	1	< 0.1%
332	1	< 0.1%
331	1	< 0.1%
330	1	< 0.1%
329	1	< 0.1%
328	1	< 0.1%
327	1	< 0.1%
326	1	< 0.1%
325	1	< 0.1%

total_cxl_appointments_before_appointment
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	134
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6344924

Minimum	0
Maximum	145
Zeros	87748
Zeros (%)	61.5%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	13
Maximum	145
Range	145
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	8.6717357
Coefficient of variation (CV)	3.2916154
Kurtosis	76.642096
Mean	2.6344924
Median Absolute Deviation (MAD)	0
Skewness	7.4385572
Sum	375647
Variance	75.199
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	87748	61.5%
1	19022	13.3%
2	8624	6.0%
3	5195	3.6%
4	3739	2.6%
5	2731	1.9%
6	2069	1.5%
7	1472	1.0%
8	1220	0.9%
9	1155	0.8%
Other values (124)	9613	6.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	87748	61.5%
1	19022	13.3%
2	8624	6.0%
3	5195	3.6%
4	3739	2.6%
5	2731	1.9%
6	2069	1.5%
7	1472	1.0%
8	1220	0.9%
9	1155	0.8%

Value	Count	Frequency (%)
145	22	< 0.1%
144	12	< 0.1%
143	22	< 0.1%
142	1	< 0.1%
141	2	< 0.1%
140	3	< 0.1%
139	2	< 0.1%
138	3	< 0.1%
137	1	< 0.1%
136	3	< 0.1%

patient_status
Categorical

IMBALANCE

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Not Yet Actioned	129550
Therapist Follow Up	7366
Has An Upcoming Booking	2191
Patient Stopped Treatment	1694
Admin Follow Up	850
Other values (5)	937

Length

Max length	25
Median length	16
Mean length	16.380516
Min length	14

Characters and Unicode

Total characters	2335665
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Yet Actioned
2nd row	Not Yet Actioned
3rd row	Not Yet Actioned
4th row	Not Yet Actioned
5th row	Not Yet Actioned

Common Values

Value	Count	Frequency (%)
Not Yet Actioned	129550	90.9%
Therapist Follow Up	7366	5.2%
Has An Upcoming Booking	2191	1.5%
Patient Stopped Treatment	1694	1.2%
Admin Follow Up	850	0.6%
Discharged By Therapist	352	0.2%
On Waiting List	322	0.2%
Staff & Family	126	0.1%
Contacted Too Many Times	81	0.1%
Do Not Contact	56	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
not	129606	30.1%
actioned	129550	30.1%
yet	129550	30.1%
follow	8216	1.9%
up	8216	1.9%
therapist	7718	1.8%
has	2191	0.5%
an	2191	0.5%
upcoming	2191	0.5%
booking	2191	0.5%
Other values (18)	8416	2.0%

Most occurring characters

Value	Count	Frequency (%)
t	405938	17.4%
	287448	12.3%
o	284210	12.2%
e	274108	11.7%
i	145719	6.2%
n	141223	6.0%
A	132591	5.7%
d	132527	5.7%
c	132230	5.7%
N	129606	5.5%
Other values (27)	270065	11.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2335665	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	405938	17.4%
	287448	12.3%
o	284210	12.2%
e	274108	11.7%
i	145719	6.2%
n	141223	6.0%
A	132591	5.7%
d	132527	5.7%
c	132230	5.7%
N	129606	5.5%
Other values (27)	270065	11.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2335665	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	405938	17.4%
	287448	12.3%
o	284210	12.2%
e	274108	11.7%
i	145719	6.2%
n	141223	6.0%
A	132591	5.7%
d	132527	5.7%
c	132230	5.7%
N	129606	5.5%
Other values (27)	270065	11.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2335665	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	405938	17.4%
	287448	12.3%
o	284210	12.2%
e	274108	11.7%
i	145719	6.2%
n	141223	6.0%
A	132591	5.7%
d	132527	5.7%
c	132230	5.7%
N	129606	5.5%
Other values (27)	270065	11.6%

patient_type
Categorical

IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Recurring	119797
new injury/issue	12173
New To Clinic	6249
new to therapist	3908
new to service	461

Length

Max length	16
Median length	9
Mean length	9.9809241
Min length	9

Characters and Unicode

Total characters	1423160
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	New To Clinic
2nd row	Recurring
3rd row	Recurring
4th row	Recurring
5th row	New To Clinic

Common Values

Value	Count	Frequency (%)
Recurring	119797	84.0%
new injury/issue	12173	8.5%
New To Clinic	6249	4.4%
new to therapist	3908	2.7%
new to service	461	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
recurring	119797	68.1%
new	22791	12.9%
injury/issue	12173	6.9%
to	10618	6.0%
clinic	6249	3.6%
therapist	3908	2.2%
service	461	0.3%

Most occurring characters

Value	Count	Frequency (%)
r	256136	18.0%
i	161010	11.3%
e	159591	11.2%
n	154761	10.9%
u	144143	10.1%
c	126507	8.9%
R	119797	8.4%
g	119797	8.4%
	33409	2.3%
s	28715	2.0%
Other values (14)	119294	8.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1423160	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	256136	18.0%
i	161010	11.3%
e	159591	11.2%
n	154761	10.9%
u	144143	10.1%
c	126507	8.9%
R	119797	8.4%
g	119797	8.4%
	33409	2.3%
s	28715	2.0%
Other values (14)	119294	8.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1423160	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	256136	18.0%
i	161010	11.3%
e	159591	11.2%
n	154761	10.9%
u	144143	10.1%
c	126507	8.9%
R	119797	8.4%
g	119797	8.4%
	33409	2.3%
s	28715	2.0%
Other values (14)	119294	8.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1423160	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	256136	18.0%
i	161010	11.3%
e	159591	11.2%
n	154761	10.9%
u	144143	10.1%
c	126507	8.9%
R	119797	8.4%
g	119797	8.4%
	33409	2.3%
s	28715	2.0%
Other values (14)	119294	8.4%

time_of_day
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Late Afternoon	68696
Late Morning	50404
Early Morning	14476
Evening	9012

Length

Max length	14
Median length	13
Mean length	12.749067
Min length	7

Characters and Unicode

Total characters	1817864
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Early Morning
2nd row	Late Afternoon
3rd row	Late Morning
4th row	Late Morning
5th row	Early Morning

Common Values

Value	Count	Frequency (%)
Late Afternoon	68696	48.2%
Late Morning	50404	35.3%
Early Morning	14476	10.2%
Evening	9012	6.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
late	119100	43.1%
afternoon	68696	24.9%
morning	64880	23.5%
early	14476	5.2%
evening	9012	3.3%

Most occurring characters

Value	Count	Frequency (%)
n	285176	15.7%
o	202272	11.1%
e	196808	10.8%
t	187796	10.3%
r	148052	8.1%
	133576	7.3%
a	133576	7.3%
L	119100	6.6%
i	73892	4.1%
g	73892	4.1%
Other values (7)	263724	14.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1817864	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	285176	15.7%
o	202272	11.1%
e	196808	10.8%
t	187796	10.3%
r	148052	8.1%
	133576	7.3%
a	133576	7.3%
L	119100	6.6%
i	73892	4.1%
g	73892	4.1%
Other values (7)	263724	14.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1817864	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	285176	15.7%
o	202272	11.1%
e	196808	10.8%
t	187796	10.3%
r	148052	8.1%
	133576	7.3%
a	133576	7.3%
L	119100	6.6%
i	73892	4.1%
g	73892	4.1%
Other values (7)	263724	14.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1817864	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	285176	15.7%
o	202272	11.1%
e	196808	10.8%
t	187796	10.3%
r	148052	8.1%
	133576	7.3%
a	133576	7.3%
L	119100	6.6%
i	73892	4.1%
g	73892	4.1%
Other values (7)	263724	14.5%

month_period
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Mid month	49458
End month	46869
Early month	46261

Length

Max length	11
Median length	9
Mean length	9.6488765
Min length	9

Characters and Unicode

Total characters	1375814
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mid month
2nd row	Mid month
3rd row	Mid month
4th row	Mid month
5th row	End month

Common Values

Value	Count	Frequency (%)
Mid month	49458	34.7%
End month	46869	32.9%
Early month	46261	32.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
month	142588	50.0%
mid	49458	17.3%
end	46869	16.4%
early	46261	16.2%

Most occurring characters

Value	Count	Frequency (%)
n	189457	13.8%
	142588	10.4%
m	142588	10.4%
o	142588	10.4%
t	142588	10.4%
h	142588	10.4%
d	96327	7.0%
E	93130	6.8%
M	49458	3.6%
i	49458	3.6%
Other values (4)	185044	13.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1375814	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	189457	13.8%
	142588	10.4%
m	142588	10.4%
o	142588	10.4%
t	142588	10.4%
h	142588	10.4%
d	96327	7.0%
E	93130	6.8%
M	49458	3.6%
i	49458	3.6%
Other values (4)	185044	13.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1375814	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	189457	13.8%
	142588	10.4%
m	142588	10.4%
o	142588	10.4%
t	142588	10.4%
h	142588	10.4%
d	96327	7.0%
E	93130	6.8%
M	49458	3.6%
i	49458	3.6%
Other values (4)	185044	13.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1375814	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	189457	13.8%
	142588	10.4%
m	142588	10.4%
o	142588	10.4%
t	142588	10.4%
h	142588	10.4%
d	96327	7.0%
E	93130	6.8%
M	49458	3.6%
i	49458	3.6%
Other values (4)	185044	13.4%

day_of_week
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Thursday	29586
Tuesday	27986
Wednesday	27877
Monday	24398
Friday	24219
Other values (3)	8522

Length

Max length	9
Median length	9
Mean length	8.9999439
Min length	8

Characters and Unicode

Total characters	1283284
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Friday
2nd row	Thursday
3rd row	Thursday
4th row	Friday
5th row	Monday

Common Values

Value	Count	Frequency (%)
Thursday	29586	20.7%
Tuesday	27986	19.6%
Wednesday	27877	19.6%
Monday	24398	17.1%
Friday	24219	17.0%
Saturday	7958	5.6%
Sunday	556	0.4%
Thursday	8	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
thursday	29594	20.8%
tuesday	27986	19.6%
wednesday	27877	19.6%
monday	24398	17.1%
friday	24219	17.0%
saturday	7958	5.6%
sunday	556	0.4%

Most occurring characters

Value	Count	Frequency (%)
	241035	18.8%
d	170465	13.3%
a	150546	11.7%
y	142588	11.1%
s	85457	6.7%
e	83740	6.5%
u	66094	5.2%
r	61771	4.8%
T	57580	4.5%
n	52831	4.1%
Other values (8)	171177	13.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1283284	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	241035	18.8%
d	170465	13.3%
a	150546	11.7%
y	142588	11.1%
s	85457	6.7%
e	83740	6.5%
u	66094	5.2%
r	61771	4.8%
T	57580	4.5%
n	52831	4.1%
Other values (8)	171177	13.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1283284	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	241035	18.8%
d	170465	13.3%
a	150546	11.7%
y	142588	11.1%
s	85457	6.7%
e	83740	6.5%
u	66094	5.2%
r	61771	4.8%
T	57580	4.5%
n	52831	4.1%
Other values (8)	171177	13.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1283284	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	241035	18.8%
d	170465	13.3%
a	150546	11.7%
y	142588	11.1%
s	85457	6.7%
e	83740	6.5%
u	66094	5.2%
r	61771	4.8%
T	57580	4.5%
n	52831	4.1%
Other values (8)	171177	13.3%

month_of_year
Categorical

HIGH CORRELATION

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

May	15437
March	14400
February	13293
June	13225
April	12850
Other values (8)	73383

Length

Max length	9
Median length	9
Mean length	8.9996634
Min length	3

Characters and Unicode

Total characters	1283244
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	July
2nd row	August
3rd row	August
4th row	September
5th row	September

Common Values

Value	Count	Frequency (%)
May	15437	10.8%
March	14400	10.1%
February	13293	9.3%
June	13225	9.3%
April	12850	9.0%
November	12360	8.7%
January	12343	8.7%
December	10663	7.5%
July	9976	7.0%
October	9622	6.7%
Other values (3)	18419	12.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
may	15445	10.8%
march	14400	10.1%
february	13293	9.3%
june	13225	9.3%
april	12850	9.0%
november	12360	8.7%
january	12343	8.7%
december	10663	7.5%
july	9976	7.0%
october	9622	6.7%
Other values (2)	18411	12.9%

Most occurring characters

Value	Count	Frequency (%)
	426589	33.2%
e	119366	9.3%
r	107663	8.4%
u	67981	5.3%
a	67824	5.3%
b	54777	4.3%
y	51057	4.0%
J	35544	2.8%
c	34685	2.7%
m	31862	2.5%
Other values (17)	285896	22.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1283244	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	426589	33.2%
e	119366	9.3%
r	107663	8.4%
u	67981	5.3%
a	67824	5.3%
b	54777	4.3%
y	51057	4.0%
J	35544	2.8%
c	34685	2.7%
m	31862	2.5%
Other values (17)	285896	22.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1283244	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	426589	33.2%
e	119366	9.3%
r	107663	8.4%
u	67981	5.3%
a	67824	5.3%
b	54777	4.3%
y	51057	4.0%
J	35544	2.8%
c	34685	2.7%
m	31862	2.5%
Other values (17)	285896	22.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1283244	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	426589	33.2%
e	119366	9.3%
r	107663	8.4%
u	67981	5.3%
a	67824	5.3%
b	54777	4.3%
y	51057	4.0%
J	35544	2.8%
c	34685	2.7%
m	31862	2.5%
Other values (17)	285896	22.3%

day_of_month
Real number (ℝ)

HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.621876

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.6301964
Coefficient of variation (CV)	0.55244304
Kurtosis	-1.1424052
Mean	15.621876
Median Absolute Deviation (MAD)	7
Skewness	0.031032972
Sum	2227492
Variance	74.48029
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
15	5290	3.7%
20	5142	3.6%
13	5108	3.6%
22	5045	3.5%
8	5008	3.5%
16	4960	3.5%
14	4955	3.5%
9	4886	3.4%
19	4868	3.4%
11	4834	3.4%
Other values (21)	92492	64.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4287	3.0%
2	4307	3.0%
3	4529	3.2%
4	4740	3.3%
5	4682	3.3%
6	4820	3.4%
7	4634	3.2%
8	5008	3.5%
9	4886	3.4%
10	4368	3.1%

Value	Count	Frequency (%)
31	2597	1.8%
30	3998	2.8%
29	4335	3.0%
28	4434	3.1%
27	4715	3.3%
26	3792	2.7%
25	3844	2.7%
24	4466	3.1%
23	4811	3.4%
22	5045	3.5%

week_of_year
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.938543

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	12
median	23
Q3	38
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	14.939448
Coefficient of variation (CV)	0.59905053
Kurtosis	-1.1777403
Mean	24.938543
Median Absolute Deviation (MAD)	13
Skewness	0.20224686
Sum	3555937
Variance	223.1871
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22	3696	2.6%
12	3505	2.5%
20	3477	2.4%
19	3431	2.4%
23	3419	2.4%
18	3366	2.4%
10	3365	2.4%
21	3359	2.4%
6	3287	2.3%
8	3257	2.3%
Other values (43)	108426	76.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1820	1.3%
2	3111	2.2%
3	3201	2.2%
4	2755	1.9%
5	3253	2.3%
6	3287	2.3%
7	3209	2.3%
8	3257	2.3%
9	3201	2.2%
10	3365	2.4%

Value	Count	Frequency (%)
53	69	< 0.1%
52	724	0.5%
51	3016	2.1%
50	3133	2.2%
49	2978	2.1%
48	2970	2.1%
47	3011	2.1%
46	3107	2.2%
45	2624	1.8%
44	2324	1.6%

appointment_status
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Not Rebooked	116141
Rebooked	26447

Length

Max length	12
Median length	12
Mean length	11.258086
Min length	8

Characters and Unicode

Total characters	1605268
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Rebooked
2nd row	Not Rebooked
3rd row	Not Rebooked
4th row	Not Rebooked
5th row	Not Rebooked

Common Values

Value	Count	Frequency (%)
Not Rebooked	116141	81.5%
Rebooked	26447	18.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rebooked	142588	55.1%
not	116141	44.9%

Most occurring characters

Value	Count	Frequency (%)
o	401317	25.0%
e	285176	17.8%
R	142588	8.9%
b	142588	8.9%
k	142588	8.9%
d	142588	8.9%
N	116141	7.2%
t	116141	7.2%
	116141	7.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1605268	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	401317	25.0%
e	285176	17.8%
R	142588	8.9%
b	142588	8.9%
k	142588	8.9%
d	142588	8.9%
N	116141	7.2%
t	116141	7.2%
	116141	7.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1605268	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	401317	25.0%
e	285176	17.8%
R	142588	8.9%
b	142588	8.9%
k	142588	8.9%
d	142588	8.9%
N	116141	7.2%
t	116141	7.2%
	116141	7.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1605268	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	401317	25.0%
e	285176	17.8%
R	142588	8.9%
b	142588	8.9%
k	142588	8.9%
d	142588	8.9%
N	116141	7.2%
t	116141	7.2%
	116141	7.2%

next_appointment_time
Date

MISSING

Distinct	13826
Distinct (%)	52.3%
Missing	116141
Missing (%)	81.5%
Memory size	1.1 MiB

Minimum	2020-10-26 10:00:00
Maximum	2026-01-01 09:30:00

Histogram

Histogram with fixed size bins (bins=50)

notice
Real number (ℝ)

ZEROS

Distinct	14995
Distinct (%)	10.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-841.51892

Minimum	-65869.14
Maximum	17186.2
Zeros	119702
Zeros (%)	83.9%
Negative	7672
Negative (%)	5.4%
Memory size	1.1 MiB

Quantile statistics

Minimum	-65869.14
5-th percentile	-1042.24
Q1	0
median	0
Q3	0
95-th percentile	27.1265
Maximum	17186.2
Range	83055.34
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	4682.9759
Coefficient of variation (CV)	-5.5649086
Kurtosis	64.831787
Mean	-841.51892
Median Absolute Deviation (MAD)	0
Skewness	-7.2020881
Sum	-1.199905 × 10⁸
Variance	21930263
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	119702	83.9%
23.58	16	< 0.1%
23.68	15	< 0.1%
22.79	14	< 0.1%
1.76	14	< 0.1%
23.27	14	< 0.1%
23.86	13	< 0.1%
1.77	13	< 0.1%
23.42	13	< 0.1%
23.48	13	< 0.1%
Other values (14985)	22761	16.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-65869.14	1	< 0.1%
-65863.14	1	< 0.1%
-65692.14	1	< 0.1%
-65578.64	1	< 0.1%
-65482.64	1	< 0.1%
-65476.14	1	< 0.1%
-65142.64	1	< 0.1%
-65020.64	1	< 0.1%
-64684.14	1	< 0.1%
-63829.14	1	< 0.1%

Value	Count	Frequency (%)
17186.2	1	< 0.1%
16850.2	1	< 0.1%
16514.2	1	< 0.1%
16178.2	1	< 0.1%
15842.2	1	< 0.1%
15506.2	1	< 0.1%
15170.2	1	< 0.1%
14834.2	1	< 0.1%
14498.2	1	< 0.1%
14162.2	1	< 0.1%

cancelled_at
Date

MISSING

Distinct	15540
Distinct (%)	67.9%
Missing	119696
Missing (%)	83.9%
Memory size	1.1 MiB

Minimum	2020-07-16 08:36:13+00:00
Maximum	2024-06-08 02:48:31+00:00

Histogram

Histogram with fixed size bins (bins=50)

appointment_type
Text

Distinct	580
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	125
Median length	98
Mean length	46.628188
Min length	4

Characters and Unicode

Total characters	6648620
Distinct characters	85
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	87 ?
Unique (%)	0.1%

Sample

1st row	✅20 Minute Follow Up Consult
2nd row	✅20 Minute Follow Up Consult
3rd row	✅20 Minute Follow Up Consult
4th row	✅20 Minute Follow Up Consult
5th row	✅20 Minute Follow Up Consult

Value	Count	Frequency (%)
	115294	11.9%
subsequent	64724	6.7%
consultation	63100	6.5%
consult	61333	6.3%
2	51540	5.3%
up	49287	5.1%
follow	49211	5.1%
minute	44288	4.6%
physiotherapy	37332	3.8%
30	28483	2.9%
Other values (384)	405940	41.8%

Most occurring characters

Value	Count	Frequency (%)
	833188	12.5%
t	527489	7.9%
o	463384	7.0%
n	434612	6.5%
e	428083	6.4%
i	366282	5.5%
s	362839	5.5%
u	328294	4.9%
l	309964	4.7%
a	278059	4.2%
Other values (75)	2316426	34.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6648620	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	833188	12.5%
t	527489	7.9%
o	463384	7.0%
n	434612	6.5%
e	428083	6.4%
i	366282	5.5%
s	362839	5.5%
u	328294	4.9%
l	309964	4.7%
a	278059	4.2%
Other values (75)	2316426	34.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6648620	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	833188	12.5%
t	527489	7.9%
o	463384	7.0%
n	434612	6.5%
e	428083	6.4%
i	366282	5.5%
s	362839	5.5%
u	328294	4.9%
l	309964	4.7%
a	278059	4.2%
Other values (75)	2316426	34.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6648620	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	833188	12.5%
t	527489	7.9%
o	463384	7.0%
n	434612	6.5%
e	428083	6.4%
i	366282	5.5%
s	362839	5.5%
u	328294	4.9%
l	309964	4.7%
a	278059	4.2%
Other values (75)	2316426	34.8%

billable_item
Text

Distinct	427
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	125
Median length	102
Mean length	44.657061
Min length	11

Characters and Unicode

Total characters	6367561
Distinct characters	73
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	48 ?
Unique (%)	< 0.1%

Sample

1st row	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)
2nd row	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)
3rd row	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)
4th row	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)
5th row	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)

Value	Count	Frequency (%)
	120453	13.7%
subsequent	68306	7.8%
consultation	65817	7.5%
consult	59976	6.8%
up	47640	5.4%
follow	47440	5.4%
osteopathy	46126	5.2%
minute	42820	4.9%
physiotherapy	36276	4.1%
30	29822	3.4%
Other values (286)	313944	35.7%

Most occurring characters

Value	Count	Frequency (%)
	758094	11.9%
t	536132	8.4%
o	465545	7.3%
n	441411	6.9%
e	417256	6.6%
i	371234	5.8%
s	371018	5.8%
u	334753	5.3%
l	314597	4.9%
a	283192	4.4%
Other values (63)	2074329	32.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6367561	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	758094	11.9%
t	536132	8.4%
o	465545	7.3%
n	441411	6.9%
e	417256	6.6%
i	371234	5.8%
s	371018	5.8%
u	334753	5.3%
l	314597	4.9%
a	283192	4.4%
Other values (63)	2074329	32.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6367561	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	758094	11.9%
t	536132	8.4%
o	465545	7.3%
n	441411	6.9%
e	417256	6.6%
i	371234	5.8%
s	371018	5.8%
u	334753	5.3%
l	314597	4.9%
a	283192	4.4%
Other values (63)	2074329	32.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6367561	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	758094	11.9%
t	536132	8.4%
o	465545	7.3%
n	441411	6.9%
e	417256	6.6%
i	371234	5.8%
s	371018	5.8%
u	334753	5.3%
l	314597	4.9%
a	283192	4.4%
Other values (63)	2074329	32.6%

category
Text

Distinct	161
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	68
Median length	62
Mean length	33.398287
Min length	3

Characters and Unicode

Total characters	4762195
Distinct characters	91
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18 ?
Unique (%)	< 0.1%

Sample

1st row	A \| Pre Pay Online & Save ✅
2nd row	A \| Pre Pay Online & Save ✅
3rd row	A \| Pre Pay Online & Save ✅
4th row	A \| Pre Pay Online & Save ✅
5th row	A \| Pre Pay Online & Save ✅

Value	Count	Frequency (%)
	89159	12.3%
2	49513	6.9%
subsequent	44285	6.1%
consultations	43930	6.1%
for	43768	6.1%
osteopathy	43204	6.0%
existing	42591	5.9%
patients	42591	5.9%
physiotherapy	34209	4.7%
a	32919	4.6%
Other values (205)	256600	35.5%

Most occurring characters

Value	Count	Frequency (%)
	581800	12.2%
t	388146	8.2%
s	343759	7.2%
e	271275	5.7%
n	251467	5.3%
o	233041	4.9%
i	222883	4.7%
a	210996	4.4%
P	154757	3.2%
u	151148	3.2%
Other values (81)	1952923	41.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4762195	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	581800	12.2%
t	388146	8.2%
s	343759	7.2%
e	271275	5.7%
n	251467	5.3%
o	233041	4.9%
i	222883	4.7%
a	210996	4.4%
P	154757	3.2%
u	151148	3.2%
Other values (81)	1952923	41.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4762195	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	581800	12.2%
t	388146	8.2%
s	343759	7.2%
e	271275	5.7%
n	251467	5.3%
o	233041	4.9%
i	222883	4.7%
a	210996	4.4%
P	154757	3.2%
u	151148	3.2%
Other values (81)	1952923	41.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4762195	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	581800	12.2%
t	388146	8.2%
s	343759	7.2%
e	271275	5.7%
n	251467	5.3%
o	233041	4.9%
i	222883	4.7%
a	210996	4.4%
P	154757	3.2%
u	151148	3.2%
Other values (81)	1952923	41.0%

cancelled
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.4 KiB

False	119696
True	22892

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	119696	83.9%
True	22892	16.1%

missed
Boolean

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.4 KiB

False	140606
True	1982

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	140606	98.6%
True	1982	1.4%

appointment_start_time
Date

Distinct	62819
Distinct (%)	44.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2009-08-15 01:30:00+00:00
Maximum	2025-12-31 23:30:00+00:00

Histogram

Histogram with fixed size bins (bins=50)

business_name
Categorical

HIGH CORRELATION

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Scarb Physio & Health	32219
All Sorted Physiotherapy	29681
Osteopathy \| Melton	26974
Osteopathy \| Bacchus Marsh	17735
Scarb Remedial Massage	8732
Other values (20)	27247

Length

Max length	30
Median length	26
Mean length	21.578597
Min length	12

Characters and Unicode

Total characters	3076849
Distinct characters	47
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	PhysioCall Gladstone
2nd row	PhysioCall Gladstone
3rd row	PhysioCall Gladstone
4th row	PhysioCall Gladstone
5th row	PhysioCall Gladstone

Common Values

Value	Count	Frequency (%)
Scarb Physio & Health	32219	22.6%
All Sorted Physiotherapy	29681	20.8%
Osteopathy \| Melton	26974	18.9%
Osteopathy \| Bacchus Marsh	17735	12.4%
Scarb Remedial Massage	8732	6.1%
PhysioCall Gladstone	6252	4.4%
Bosch Psychology	5753	4.0%
Newport Physiotherapy	5153	3.6%
Newport Psychology	4207	3.0%
Physiotherapy \| Melton	1407	1.0%
Other values (15)	4475	3.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	80527	17.6%
osteopathy	44709	9.8%
scarb	41897	9.2%
physiotherapy	36410	8.0%
health	32873	7.2%
physio	32219	7.0%
all	29681	6.5%
sorted	29681	6.5%
melton	29331	6.4%
bacchus	18375	4.0%
Other values (25)	81710	17.9%

Most occurring characters

Value	Count	Frequency (%)
	314825	10.2%
h	242304	7.9%
a	235913	7.7%
t	235743	7.7%
o	225274	7.3%
e	218725	7.1%
s	202344	6.6%
y	177814	5.8%
l	161340	5.2%
r	137624	4.5%
Other values (37)	924943	30.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3076849	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	314825	10.2%
h	242304	7.9%
a	235913	7.7%
t	235743	7.7%
o	225274	7.3%
e	218725	7.1%
s	202344	6.6%
y	177814	5.8%
l	161340	5.2%
r	137624	4.5%
Other values (37)	924943	30.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3076849	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	314825	10.2%
h	242304	7.9%
a	235913	7.7%
t	235743	7.7%
o	225274	7.3%
e	218725	7.1%
s	202344	6.6%
y	177814	5.8%
l	161340	5.2%
r	137624	4.5%
Other values (37)	924943	30.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3076849	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	314825	10.2%
h	242304	7.9%
a	235913	7.7%
t	235743	7.7%
o	225274	7.3%
e	218725	7.1%
s	202344	6.6%
y	177814	5.8%
l	161340	5.2%
r	137624	4.5%
Other values (37)	924943	30.1%

customer_type
Categorical

IMBALANCE

Distinct	36
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

No Type	103758
WorkCover	5945
NDIS	5638
Concession / Pension Card Holder	5346
Medicare Referrals	4281
Other values (31)	17620

Length

Max length	32
Median length	7
Mean length	8.4507252
Min length	3

Characters and Unicode

Total characters	1204972
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Staff
2nd row	No Type
3rd row	No Type
4th row	No Type
5th row	No Type

Common Values

Value	Count	Frequency (%)
No Type	103758	72.8%
WorkCover	5945	4.2%
NDIS	5638	4.0%
Concession / Pension Card Holder	5346	3.7%
Medicare Referrals	4281	3.0%
DVA	3120	2.2%
NDIS Customer	2474	1.7%
CDM	2449	1.7%
DVA Card Holder	2188	1.5%
Third Party	1716	1.2%
Other values (26)	5673	4.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
no	103758	36.5%
type	103758	36.5%
ndis	8112	2.9%
card	7538	2.7%
holder	7534	2.7%
workcover	6158	2.2%
	5923	2.1%
medicare	5621	2.0%
concession	5408	1.9%
pension	5346	1.9%
Other values (39)	24964	8.8%

Most occurring characters

Value	Count	Frequency (%)
e	154467	12.8%
o	143313	11.9%
	141967	11.8%
N	111870	9.3%
T	106099	8.8%
y	105967	8.8%
p	103935	8.6%
r	49464	4.1%
d	24831	2.1%
C	24721	2.1%
Other values (36)	238338	19.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1204972	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	154467	12.8%
o	143313	11.9%
	141967	11.8%
N	111870	9.3%
T	106099	8.8%
y	105967	8.8%
p	103935	8.6%
r	49464	4.1%
d	24831	2.1%
C	24721	2.1%
Other values (36)	238338	19.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1204972	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	154467	12.8%
o	143313	11.9%
	141967	11.8%
N	111870	9.3%
T	106099	8.8%
y	105967	8.8%
p	103935	8.6%
r	49464	4.1%
d	24831	2.1%
C	24721	2.1%
Other values (36)	238338	19.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1204972	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	154467	12.8%
o	143313	11.9%
	141967	11.8%
N	111870	9.3%
T	106099	8.8%
y	105967	8.8%
p	103935	8.6%
r	49464	4.1%
d	24831	2.1%
C	24721	2.1%
Other values (36)	238338	19.8%

title
Categorical

IMBALANCE

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Mr	52021
Mrs	41830
Ms	34822
Miss	8307
Master	1545
Other values (28)	4063

Length

Max length	15
Median length	2
Mean length	2.4739108
Min length	1

Characters and Unicode

Total characters	352750
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	Mr
2nd row	Mrs
3rd row	Mr
4th row	Ms
5th row	Mr

Common Values

Value	Count	Frequency (%)
Mr	52021	36.5%
Mrs	41830	29.3%
Ms	34822	24.4%
Miss	8307	5.8%
Master	1545	1.1%
	1470	1.0%
MISS	928	0.7%
Dr	681	0.5%
MASTER	355	0.2%
Mrs	185	0.1%
Other values (23)	444	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mr	52234	37.0%
mrs	42016	29.8%
ms	34892	24.7%
miss	9241	6.5%
master	1900	1.3%
dr	681	0.5%
mast	70	< 0.1%
maste	22	< 0.1%
mx	17	< 0.1%
sr	10	< 0.1%
Other values (9)	32	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
M	140390	39.8%
r	96484	27.4%
s	95175	27.0%
i	8317	2.4%
S	2225	0.6%
	2153	0.6%
a	1651	0.5%
t	1645	0.5%
e	1580	0.4%
I	928	0.3%
Other values (16)	2202	0.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	352750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	140390	39.8%
r	96484	27.4%
s	95175	27.0%
i	8317	2.4%
S	2225	0.6%
	2153	0.6%
a	1651	0.5%
t	1645	0.5%
e	1580	0.4%
I	928	0.3%
Other values (16)	2202	0.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	352750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	140390	39.8%
r	96484	27.4%
s	95175	27.0%
i	8317	2.4%
S	2225	0.6%
	2153	0.6%
a	1651	0.5%
t	1645	0.5%
e	1580	0.4%
I	928	0.3%
Other values (16)	2202	0.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	352750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	140390	39.8%
r	96484	27.4%
s	95175	27.0%
i	8317	2.4%
S	2225	0.6%
	2153	0.6%
a	1651	0.5%
t	1645	0.5%
e	1580	0.4%
I	928	0.3%
Other values (16)	2202	0.6%

state
Text

Distinct	74
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	17
Median length	3
Mean length	3.0883314
Min length	1

Characters and Unicode

Total characters	440359
Distinct characters	56
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	< 0.1%

Sample

1st row	QLD
2nd row	VIC
3rd row	VIC
4th row	QLD
5th row	VIC

Value	Count	Frequency (%)
qld	108325	75.9%
vic	31631	22.2%
queensland	1293	0.9%
nsw	785	0.5%
west	155	0.1%
gladstone	153	0.1%
victoria	107	0.1%
wa	47	< 0.1%
newport	22	< 0.1%
sa	19	< 0.1%
Other values (55)	247	0.2%

Most occurring characters

Value	Count	Frequency (%)
Q	109532	24.9%
L	83268	18.9%
D	83249	18.9%
V	31736	7.2%
I	30772	7.0%
C	30617	7.0%
d	26587	6.0%
l	26581	6.0%
e	2993	0.7%
n	2820	0.6%
Other values (46)	12204	2.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	440359	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
Q	109532	24.9%
L	83268	18.9%
D	83249	18.9%
V	31736	7.2%
I	30772	7.0%
C	30617	7.0%
d	26587	6.0%
l	26581	6.0%
e	2993	0.7%
n	2820	0.6%
Other values (46)	12204	2.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	440359	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
Q	109532	24.9%
L	83268	18.9%
D	83249	18.9%
V	31736	7.2%
I	30772	7.0%
C	30617	7.0%
d	26587	6.0%
l	26581	6.0%
e	2993	0.7%
n	2820	0.6%
Other values (46)	12204	2.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	440359	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
Q	109532	24.9%
L	83268	18.9%
D	83249	18.9%
V	31736	7.2%
I	30772	7.0%
C	30617	7.0%
d	26587	6.0%
l	26581	6.0%
e	2993	0.7%
n	2820	0.6%
Other values (46)	12204	2.8%

date_of_birth
Text

Distinct	18932
Distinct (%)	13.3%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	10
Median length	10
Mean length	9.8734396
Min length	3

Characters and Unicode

Total characters	1407834
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5922 ?
Unique (%)	4.2%

Sample

1st row	1984-02-03
2nd row	1997-01-30
3rd row	1997-01-30
4th row	1997-01-30
5th row	1980-02-03

Value	Count	Frequency (%)
may	2578	1.8%
1977-05-28	439	0.3%
1946-11-30	343	0.2%
1975-09-02	328	0.2%
1978-07-17	310	0.2%
1957-09-13	285	0.2%
1958-09-02	281	0.2%
1966-01-04	255	0.2%
1977-09-05	239	0.2%
1994-12-19	230	0.2%
Other values (18922)	137300	96.3%

Most occurring characters

Value	Count	Frequency (%)
-	280020	19.9%
1	259265	18.4%
0	214172	15.2%
9	181015	12.9%
2	112513	8.0%
8	67160	4.8%
7	66980	4.8%
6	63678	4.5%
5	58327	4.1%
4	49235	3.5%
Other values (4)	55469	3.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1407834	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	280020	19.9%
1	259265	18.4%
0	214172	15.2%
9	181015	12.9%
2	112513	8.0%
8	67160	4.8%
7	66980	4.8%
6	63678	4.5%
5	58327	4.1%
4	49235	3.5%
Other values (4)	55469	3.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1407834	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	280020	19.9%
1	259265	18.4%
0	214172	15.2%
9	181015	12.9%
2	112513	8.0%
8	67160	4.8%
7	66980	4.8%
6	63678	4.5%
5	58327	4.1%
4	49235	3.5%
Other values (4)	55469	3.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1407834	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	280020	19.9%
1	259265	18.4%
0	214172	15.2%
9	181015	12.9%
2	112513	8.0%
8	67160	4.8%
7	66980	4.8%
6	63678	4.5%
5	58327	4.1%
4	49235	3.5%
Other values (4)	55469	3.9%

sex
Categorical

IMBALANCE

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Female	81426
Male	59436
9	1405
female	152
male	143
Other values (3)	26

Length

Max length	6
Median length	6
Mean length	5.1147853
Min length	1

Characters and Unicode

Total characters	729307
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Male
2nd row	Female
3rd row	Female
4th row	Female
5th row	Female

Common Values

Value	Count	Frequency (%)
Female	81426	57.1%
Male	59436	41.7%
9	1405	1.0%
female	152	0.1%
male	143	0.1%
Other	13	< 0.1%
AMAB	12	< 0.1%
other	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	81578	57.2%
male	59579	41.8%
9	1405	1.0%
other	14	< 0.1%
amab	12	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	222749	30.5%
a	141157	19.4%
l	141157	19.4%
m	81721	11.2%
F	81426	11.2%
M	59448	8.2%
9	1405	0.2%
f	152	< 0.1%
A	24	< 0.1%
t	14	< 0.1%
Other values (5)	54	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	729307	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	222749	30.5%
a	141157	19.4%
l	141157	19.4%
m	81721	11.2%
F	81426	11.2%
M	59448	8.2%
9	1405	0.2%
f	152	< 0.1%
A	24	< 0.1%
t	14	< 0.1%
Other values (5)	54	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	729307	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	222749	30.5%
a	141157	19.4%
l	141157	19.4%
m	81721	11.2%
F	81426	11.2%
M	59448	8.2%
9	1405	0.2%
f	152	< 0.1%
A	24	< 0.1%
t	14	< 0.1%
Other values (5)	54	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	729307	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	222749	30.5%
a	141157	19.4%
l	141157	19.4%
m	81721	11.2%
F	81426	11.2%
M	59448	8.2%
9	1405	0.2%
f	152	< 0.1%
A	24	< 0.1%
t	14	< 0.1%
Other values (5)	54	< 0.1%

city
Text

Distinct	901
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	43
Median length	27
Mean length	9.262743
Min length	2

Characters and Unicode

Total characters	1320756
Distinct characters	69
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	170 ?
Unique (%)	0.1%

Sample

1st row	South Gladstone
2nd row	Clontarf
3rd row	GLADSTONE
4th row	Clontarf
5th row	Scarborough

Value	Count	Frequency (%)
scarborough	32320	19.9%
gladstone	26017	16.0%
newport	18417	11.3%
redcliffe	12432	7.7%
margate	8798	5.4%
clontarf	7991	4.9%
bay	2570	1.6%
deception	2523	1.6%
kippa	2198	1.4%
ring	2198	1.4%
Other values (627)	46856	28.9%

Most occurring characters

Value	Count	Frequency (%)
o	109151	8.3%
r	106638	8.1%
a	78843	6.0%
e	73269	5.5%
S	62109	4.7%
N	56822	4.3%
c	48422	3.7%
t	47849	3.6%
g	46509	3.5%
l	37651	2.9%
Other values (59)	653493	49.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1320756	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	109151	8.3%
r	106638	8.1%
a	78843	6.0%
e	73269	5.5%
S	62109	4.7%
N	56822	4.3%
c	48422	3.7%
t	47849	3.6%
g	46509	3.5%
l	37651	2.9%
Other values (59)	653493	49.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1320756	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	109151	8.3%
r	106638	8.1%
a	78843	6.0%
e	73269	5.5%
S	62109	4.7%
N	56822	4.3%
c	48422	3.7%
t	47849	3.6%
g	46509	3.5%
l	37651	2.9%
Other values (59)	653493	49.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1320756	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	109151	8.3%
r	106638	8.1%
a	78843	6.0%
e	73269	5.5%
S	62109	4.7%
N	56822	4.3%
c	48422	3.7%
t	47849	3.6%
g	46509	3.5%
l	37651	2.9%
Other values (59)	653493	49.5%

occupation
Text

Distinct	3868
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	57
Median length	56
Mean length	12.356012
Min length	1

Characters and Unicode

Total characters	1761819
Distinct characters	80
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1322 ?
Unique (%)	0.9%

Sample

1st row	Physio
2nd row	No Occupation
3rd row	No Occupation
4th row	No Occupation
5th row	No Occupation

Value	Count	Frequency (%)
no	68153	26.9%
occupation	68112	26.9%
retired	14268	5.6%
student	5763	2.3%
manager	4207	1.7%
teacher	3681	1.5%
worker	2161	0.9%
nurse	2001	0.8%
officer	1833	0.7%
assistant	1816	0.7%
Other values (2083)	81266	32.1%

Most occurring characters

Value	Count	Frequency (%)
o	174290	9.9%
c	169237	9.6%
t	142403	8.1%
i	134390	7.6%
a	123534	7.0%
n	118508	6.7%
e	117204	6.7%
	112996	6.4%
u	92551	5.3%
r	85633	4.9%
Other values (70)	491073	27.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1761819	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	174290	9.9%
c	169237	9.6%
t	142403	8.1%
i	134390	7.6%
a	123534	7.0%
n	118508	6.7%
e	117204	6.7%
	112996	6.4%
u	92551	5.3%
r	85633	4.9%
Other values (70)	491073	27.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1761819	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	174290	9.9%
c	169237	9.6%
t	142403	8.1%
i	134390	7.6%
a	123534	7.0%
n	118508	6.7%
e	117204	6.7%
	112996	6.4%
u	92551	5.3%
r	85633	4.9%
Other values (70)	491073	27.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1761819	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	174290	9.9%
c	169237	9.6%
t	142403	8.1%
i	134390	7.6%
a	123534	7.0%
n	118508	6.7%
e	117204	6.7%
	112996	6.4%
u	92551	5.3%
r	85633	4.9%
Other values (70)	491073	27.9%

referred
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.4 KiB

False	97591
True	44997

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	97591	68.4%
True	44997	31.6%

Auto

Heatmap
Table

	appointment_status	business_name	cancelled	case_linked	case_type	customer_type	day_of_month	day_of_week	hospital_id	missed	month_of_year	month_period	notice	patient_status	patient_type	referred	sex	time_of_day	title	total_cxl_appointments_before_appointment	total_good_appointments_before_appointment	total_open_invoices_before_appointemnt	week_of_year
appointment_status	1.000	0.325	0.016	0.286	0.287	0.457	0.000	0.061	-0.127	0.016	0.040	0.000	0.096	0.196	0.138	0.121	0.052	0.083	0.081	0.279	0.368	0.261	-0.017
business_name	0.325	1.000	0.223	0.673	0.445	0.175	-0.002	0.392	-0.362	0.042	0.295	0.020	0.259	0.118	0.160	0.671	0.101	0.180	0.081	-0.048	0.064	0.080	-0.036
cancelled	0.016	0.223	1.000	0.104	0.112	0.060	-0.003	0.024	-0.091	0.052	0.018	0.001	0.328	0.019	0.182	0.000	0.051	0.054	0.055	0.278	0.041	0.026	0.004
case_linked	0.286	0.673	0.104	1.000	1.000	0.379	-0.001	0.093	-0.390	0.032	0.096	0.000	0.180	0.201	0.083	0.443	0.119	0.145	0.168	0.123	0.331	0.128	-0.078
case_type	0.287	0.445	0.112	1.000	1.000	0.304	-0.003	0.061	-0.027	0.041	0.059	0.001	0.116	0.120	0.054	0.455	0.070	0.092	0.102	0.072	0.183	0.060	-0.045
customer_type	0.457	0.175	0.060	0.379	0.304	1.000	0.001	0.056	0.184	0.044	0.028	0.006	-0.074	0.122	0.075	0.339	0.060	0.121	0.078	-0.134	-0.112	0.001	-0.021
day_of_month	0.000	-0.002	-0.003	-0.001	-0.003	0.001	1.000	0.033	0.002	0.004	0.073	0.964	0.003	0.003	0.007	0.006	0.002	0.005	0.002	-0.005	-0.005	0.008	0.050
day_of_week	0.061	0.392	0.024	0.093	0.061	0.056	0.033	1.000	-0.006	0.006	0.379	0.031	0.012	0.014	0.065	0.074	0.017	0.138	0.021	0.020	0.038	0.006	-0.017
hospital_id	-0.127	-0.362	-0.091	-0.390	-0.027	0.184	0.002	-0.006	1.000	0.021	0.584	0.011	-0.127	0.071	0.149	0.400	0.079	0.126	0.136	-0.255	-0.197	-0.095	-0.009
missed	0.016	0.042	0.052	0.032	0.041	0.044	0.004	0.006	0.021	1.000	0.023	0.000	-0.017	0.026	0.044	0.020	0.029	0.007	0.022	0.014	0.020	0.029	-0.002
month_of_year	0.040	0.295	0.018	0.096	0.059	0.028	0.073	0.379	0.584	0.023	1.000	0.078	-0.027	0.056	0.048	0.051	0.012	0.019	0.016	0.012	-0.017	-0.009	0.308
month_period	0.000	0.020	0.001	0.000	0.001	0.006	0.964	0.031	0.011	0.000	0.078	1.000	-0.002	0.004	0.006	0.001	0.000	0.000	0.000	-0.001	-0.002	-0.001	0.035
notice	0.096	0.259	0.328	0.180	0.116	-0.074	0.003	0.012	-0.127	-0.017	-0.027	-0.002	1.000	0.023	0.079	0.133	0.024	0.042	0.038	-0.139	0.023	0.048	-0.033
patient_status	0.196	0.118	0.019	0.201	0.120	0.122	0.003	0.014	0.071	0.026	0.056	0.004	0.023	1.000	0.045	0.128	0.026	0.028	0.040	0.080	0.096	-0.012	-0.065
patient_type	0.138	0.160	0.182	0.083	0.054	0.075	0.007	0.065	0.149	0.044	0.048	0.006	0.079	0.045	1.000	0.084	0.030	0.122	0.038	-0.055	-0.035	-0.027	0.023
referred	0.121	0.671	0.000	0.443	0.455	0.339	0.006	0.074	0.400	0.020	0.051	0.001	0.133	0.128	0.084	1.000	0.081	0.154	0.223	0.071	0.106	0.031	-0.021
sex	0.052	0.101	0.051	0.119	0.070	0.060	0.002	0.017	0.079	0.029	0.012	0.000	0.024	0.026	0.030	0.081	1.000	0.033	0.191	-0.090	-0.034	0.038	-0.006
time_of_day	0.083	0.180	0.054	0.145	0.092	0.121	0.005	0.138	0.126	0.007	0.019	0.000	0.042	0.028	0.122	0.154	0.033	1.000	0.057	0.042	0.021	0.029	0.002
title	0.081	0.081	0.055	0.168	0.102	0.078	0.002	0.021	0.136	0.022	0.016	0.000	0.038	0.040	0.038	0.223	0.191	0.057	1.000	0.015	-0.006	-0.006	-0.006
total_cxl_appointments_before_appointment	0.279	-0.048	0.278	0.123	0.072	-0.134	-0.005	0.020	-0.255	0.014	0.012	-0.001	-0.139	0.080	-0.055	0.071	-0.090	0.042	0.015	1.000	0.570	0.192	0.020
total_good_appointments_before_appointment	0.368	0.064	0.041	0.331	0.183	-0.112	-0.005	0.038	-0.197	0.020	-0.017	-0.002	0.023	0.096	-0.035	0.106	-0.034	0.021	-0.006	0.570	1.000	0.252	-0.015
total_open_invoices_before_appointemnt	0.261	0.080	0.026	0.128	0.060	0.001	0.008	0.006	-0.095	0.029	-0.009	-0.001	0.048	-0.012	-0.027	0.031	0.038	0.029	-0.006	0.192	0.252	1.000	-0.017
week_of_year	-0.017	-0.036	0.004	-0.078	-0.045	-0.021	0.050	-0.017	-0.009	-0.002	0.308	0.035	-0.033	-0.065	0.023	-0.021	-0.006	0.002	-0.006	0.020	-0.015	-0.017	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	hospital_id	case_linked	case_type	total_good_appointments_before_appointment	patient_status	patient_type	time_of_day	month_period	day_of_week	month_of_year	day_of_month	week_of_year	appointment_status	next_appointment_time	notice	cancelled_at	appointment_type	billable_item	category	cancelled	missed	appointment_start_time	business_name	customer_type	title	state	date_of_birth	sex	city	occupation	referred
0	11	No	Not Available	0	Not Yet Actioned	New To Clinic	Early Morning	Mid month	Friday	July	17.0	29.0	Not Rebooked	NaN	12.73	2020-07-16 08:36:13+00	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	Yes	No	2020-07-16 21:20:00+00	PhysioCall Gladstone	Staff	Mr	QLD	1984-02-03	Male	South Gladstone	Physio	Yes
1	11	No	Not Available	0	Not Yet Actioned	Recurring	Late Afternoon	Mid month	Thursday	August	13.0	33.0	Not Rebooked	NaN	0.00	NaN	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	No	No	2020-08-13 06:00:00+00	PhysioCall Gladstone	No Type	Mrs	VIC	1997-01-30	Female	Clontarf	No Occupation	No
2	11	No	Not Available	1	Not Yet Actioned	Recurring	Late Morning	Mid month	Thursday	August	20.0	34.0	Not Rebooked	NaN	0.00	NaN	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	No	No	2020-08-20 01:20:00+00	PhysioCall Gladstone	No Type	Mr	VIC	1997-01-30	Female	GLADSTONE	No Occupation	No
3	11	No	Not Available	2	Not Yet Actioned	Recurring	Late Morning	Mid month	Friday	September	18.0	38.0	Not Rebooked	NaN	0.00	NaN	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	No	No	2020-09-17 23:50:00+00	PhysioCall Gladstone	No Type	Ms	QLD	1997-01-30	Female	Clontarf	No Occupation	No
4	11	No	Not Available	0	Not Yet Actioned	New To Clinic	Early Morning	End month	Monday	September	21.0	39.0	Not Rebooked	NaN	0.00	NaN	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	No	No	2020-09-20 22:20:00+00	PhysioCall Gladstone	No Type	Mr	VIC	1980-02-03	Female	Scarborough	No Occupation	No
5	11	No	Not Available	0	Not Yet Actioned	Recurring	Late Afternoon	Mid month	Tuesday	October	20.0	43.0	Not Rebooked	NaN	0.00	NaN	✅40 Minute Follow Up Consult	Subsequent Consultation week day	1. PhysioCall - Pre Pay Online & Save ✅	No	No	2020-10-20 05:10:00+00	PhysioCall Gladstone	No Type	Mr	QLD	1977-06-30	Female	Clinton	Remedial massage therapist	Yes
6	11	No	Not Available	0	Not Yet Actioned	new injury/issue	Evening	Mid month	Sunday	October	18.0	42.0	Not Rebooked	NaN	0.00	NaN	✅60 Minute - Initial Consult Massage	Subsequent Consultation week day	1. Gladstone Massage - Prepay Online & Save ✅	No	No	2020-10-18 10:30:00+00	Gladstone Massage	No Type	Ms	VIC	1988-07-09	Male	Redcliffe	No Occupation	No
7	11	Yes	Unlimited	0	Not Yet Actioned	Recurring	Late Morning	Mid month	Monday	October	19.0	43.0	Not Rebooked	NaN	0.00	NaN	2. 20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult	A \| Physiotherapy Treatment ❤️‍🩹 (in clinic)	No	No	2020-10-19 00:40:00+00	PhysioCall Gladstone	No Type	Mr	QLD	1979-09-18	Female	Newport	No Occupation	No
8	11	No	Not Available	0	Not Yet Actioned	Recurring	Late Morning	Mid month	Monday	October	19.0	43.0	Not Rebooked	NaN	0.00	NaN	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	No	No	2020-10-19 01:00:00+00	PhysioCall Gladstone	No Type	Ms	QLD	1994-01-16	Female	GLADSTONE	No Occupation	No
9	11	Yes	Unlimited	0	Not Yet Actioned	Recurring	Late Morning	Mid month	Monday	October	19.0	43.0	Not Rebooked	NaN	0.00	NaN	40 Minute Follow Up Consult	Osteopathy - Subsequent Consultation with Supervising Clinician	2. PhysioCall - Pay In Clinic	No	No	2020-10-19 01:20:00+00	PhysioCall Gladstone	No Type	Miss	QLD	1994-03-05	Female	Gladstone	QAL Operator	Yes

	hospital_id	case_linked	case_type	total_good_appointments_before_appointment	total_cxl_appointments_before_appointment	patient_status	patient_type	time_of_day	month_period	day_of_week	month_of_year	day_of_month	week_of_year	appointment_status	next_appointment_time	cancelled_at	appointment_type	billable_item	category	cancelled	missed	appointment_start_time	business_name	customer_type	title	state	date_of_birth	sex	city	occupation	referred
142578	16	Yes	Max Sessions	11	3	Therapist Follow Up	Recurring	Late Afternoon	Mid month	Saturday	July	20.0	29.0	Not Rebooked	NaN	NaN	✨ Osteopathy CDM - Subsequent Consultation	Osteopathy CDM - Subsequent Consultation	CDM (Medicare / GP Referrals)	No	No	2024-07-20 02:00:00+00	Osteopathy \| Melton	No Type	Mr	VIC	1994-04-07	Female	Newport	Administration	No
142579	16	No	Not Available	2	1	Patient Stopped Treatment	Recurring	Late Afternoon	End month	Saturday	June	22.0	25.0	Not Rebooked	NaN	NaN	✨ Osteopathy - Subsequent Consultation	Osteopathy - Subsequent Consultation	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2024-06-22 02:00:00+00	Osteopathy \| Melton	No Type	Mr	Qld	1979-10-26	Female	GLADSTONE	No Occupation	No
142580	16	Yes	Unlimited	16	1	Has An Upcoming Booking	Recurring	Late Morning	Mid month	Wednesday	June	19.0	25.0	Rebooked	2024-06-22 10:30:00	NaN	2. Physiotherapy WorkSafe - Subsequent Consultation	Physiotherapy WorkSafe - Subsequent Consultation	WorkSafe	No	No	2024-06-19 00:30:00+00	Physiotherapy \| Melton	No Type	Mr	VIC	1989-10-06	Male	Scarborough	No Occupation	No
142581	16	Yes	Unlimited	17	1	Has An Upcoming Booking	Recurring	Late Morning	End month	Saturday	June	22.0	25.0	Rebooked	2024-06-26 10:30:00	NaN	2. Physiotherapy WorkSafe - Subsequent Consultation	Physiotherapy WorkSafe - Subsequent Consultation	WorkSafe	No	No	2024-06-22 00:30:00+00	Physiotherapy \| Melton	No Type	Mr	Qld	1989-10-06	Male	Newport	No Occupation	No
142582	16	Yes	Unlimited	18	1	Has An Upcoming Booking	Recurring	Late Morning	End month	Wednesday	June	26.0	26.0	Rebooked	2024-06-29 11:00:00	NaN	2. Physiotherapy WorkSafe - Subsequent Consultation	Physiotherapy WorkSafe - Subsequent Consultation	WorkSafe	No	No	2024-06-26 00:30:00+00	Physiotherapy \| Melton	No Type	Mr	VIC	1989-10-06	Male	Newport	No Occupation	No
142583	16	No	Not Available	28	4	Admin Follow Up	Recurring	Late Afternoon	Mid month	Tuesday	June	18.0	25.0	Not Rebooked	NaN	NaN	⭐️ Osteopathy - Subsequent Consultation With Senior Osteopath	Osteopathy - Subsequent Consultation With Senior Osteopath	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2024-06-18 02:00:00+00	Osteopathy \| Bacchus Marsh	No Type	Mrs	Qld	1989-02-17	Female	Redcliffe	Courier	No
142584	16	Yes	Unlimited	19	1	Has An Upcoming Booking	Recurring	Late Morning	End month	Saturday	June	29.0	26.0	Not Rebooked	NaN	NaN	2. Physiotherapy WorkSafe - Subsequent Consultation	Physiotherapy WorkSafe - Subsequent Consultation	WorkSafe	No	No	2024-06-29 01:00:00+00	Physiotherapy \| Melton	No Type	Mr	VIC	1989-10-06	Male	Scarborough	No Occupation	No
142585	16	Yes	Unlimited	10	0	Not Yet Actioned	Recurring	Late Afternoon	Mid month	Monday	June	17.0	25.0	Not Rebooked	NaN	NaN	✨ Osteopathy - Subsequent Consultation	Osteopathy - Subsequent Consultation	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2024-06-17 05:15:00+00	Osteopathy \| Bacchus Marsh	No Type	Mrs	VIC	1963-12-18	Female	Bacchus Marsh	Woolworths team member	Yes
142586	16	No	Not Available	2	0	Not Yet Actioned	Recurring	Evening	Mid month	Wednesday	June	12.0	24.0	Not Rebooked	NaN	NaN	⭐️ Osteopathy - Subsequent Consultation With Senior Osteopath	Osteopathy - Subsequent Consultation With Senior Osteopath	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2024-06-12 09:30:00+00	Osteopathy \| Bacchus Marsh	No Type	Ms	VIC	1968-05-28	Male	Margate	No Occupation	No
142587	16	Yes	Unlimited	17	4	Therapist Follow Up	Recurring	Late Afternoon	Mid month	Wednesday	June	19.0	25.0	Not Rebooked	NaN	NaN	⭐️ Osteopathy - Subsequent Consultation With Senior Osteopath	Osteopathy - Subsequent Consultation With Senior Osteopath	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2024-06-19 05:00:00+00	Osteopathy \| Melton	NDIS	Ms	VIc	1955-11-08	Female	Melton South	Self Employed	No

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)